insert into pub_page_templet(pk_page_templet,appcode,clazz,code,creationtime,creator,dr,headcode,isdefault,metaid,modifiedtime,modifier,name,pagecode,parentid,pk_group,pk_org,resid,resmodule,templetdesc,ts)
values('0001ZZZZ534ef416c5d9','60071051',null,'60071051_FileRole',null,'~',0,'head','Y',null,null,'~','文件权限配置','60071051_FileRole','root',null,null,'60071051_0001',null,null,'2022-02-20 13:34:57');
go

insert into pub_area(pk_area,areadesc,areastatus,areatype,clazz,code,creationtime,creator,dr,isunfold,metaid,metaname,metaspace,modifiedtime,modifier,name,pagination,position,relationcode,resid,templetid,ts)
values('0001ZZZZ85b4ec0de031','文件权限配置查询模板',null,0,null,'search','2022-02-20 13:34:57','~',0,'Y','5f665521-9f88-4008-8a24-b8678bd39f94','附件权限管理','hrhi.filerole',null,'~','文件权限配置查询模板','false',1,null,'60071051_0002','0001ZZZZ534ef416c5d9','2022-02-20 13:34:57');
go

insert into pub_area(pk_area,areadesc,areastatus,areatype,clazz,code,creationtime,creator,dr,isunfold,metaid,metaname,metaspace,modifiedtime,modifier,name,pagination,position,relationcode,resid,templetid,ts)
values('0001ZZZZ345ddf6741d0','文件权限配置',null,2,'nc.vo.hi.file.FileRoleVO','head','2022-02-20 13:34:57','~',0,'Y','5f665521-9f88-4008-8a24-b8678bd39f94','附件权限管理','hrhi.filerole',null,'~','文件权限配置','false',2,null,'60071051_0003','0001ZZZZ534ef416c5d9','2022-02-20 13:34:57');
go


            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZe08375ca918c','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','pk_role',null,null,'~',204,'0001Z01000000003FR99,code=N','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','业务角色',20,'uap.Role.role_name','pk_role','=@','等于@',6,'9200d888-fd4c-43e8-b67f-129463ee3f9e','','/common-ref/','角色','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ33b05acd91dd','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','pk_filerole',null,null,'~',1,'','','','','','','','N',0,'N','N','N','N','N','Y','Y','Y','input','主键',50,NULL,'pk_filerole','=@','等于@',1,'3d3cf1ce-3d8e-4718-8844-4cbe4ddfbbac','','/common-ref/','-99','N','','refpk',1,'','2022-02-20 13:34:57','N','N',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZb5748d418c24','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','modifier',null,null,'~',204,'0001Z01000000001BVPB,code=N','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','修改人',20,'uap.user.user_name','modifier','=@','等于@',9,'9d2382d4-5e53-4c5a-93e5-7303cd5846f2','','/common-ref/','用户','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ186c2660d71b','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','modifiedtime',null,null,'~',34,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','datetimepicker','修改时间',19,NULL,'modifiedtime','=@','等于@',10,'70c7805b-27d0-4a4f-adb9-64ded6300471','','/common-ref/','-99','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ96a94a10b8f7','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','creator',null,null,'~',204,'0001Z01000000001BVPB,code=N','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','创建人',20,'uap.user.user_name','creator','=@','等于@',7,'85cb4d17-43ee-424b-9421-9e9c9c1e45dc','','/common-ref/','用户','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ5dbb6f8d7dee','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','creationtime',null,null,'~',34,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','datetimepicker','创建时间',19,NULL,'creationtime','=@','等于@',8,'0328e805-7556-4c22-b2e6-2289cb7a1d7d','','/common-ref/','-99','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZdf5e7b9a99bb','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','pk_filetype',null,null,'~',1,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','input','文件类别',50,NULL,'pk_filetype','=@','等于@',5,'b0aa7357-973e-4c92-803f-1001f4c48321','','/common-ref/','-99','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ9197e60c0c48','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','pk_org',null,null,'~',204,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','组织',20,NULL,'pk_org','=@','等于@',3,'5009bee2-9c72-470e-8337-96819797769f','','/common-ref/','组织','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ03da966120d0','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','pk_org_v',null,null,'~',204,'','','','','','','','N',0,'N','N','N','N','N','N','Y','Y','refer','组织版本',20,NULL,'pk_org_v','=@','等于@',4,'5a48c03f-8fd8-46f6-a350-9ab929cbe861','','/common-ref/','组织_版本信息','N','','refpk',1,'','2022-02-20 13:34:57','N','N',null,1);
            go
            insert into pub_query_property(pk_query_property,areaid,classid,code,containlower,creationtime,creator,datatype,dataval,defaultvalue,define1,define2,define3,define4,define5,disabled,dr,isbeyondorg,ischeck,isdefined,isfixedcondition,ismultiselectedenabled,isnotmeta,isquerycondition,isuse,itemtype,label,maxlength,metadataproperty,metapath,opersign,opersignname,position,proid,querytablename,refcode,refname,required,resid,returntype,showtype,tablecode,ts,usefunc,visible,visibleposition,width)
            values('0001ZZZZ33f0ff9f6e1e','0001ZZZZ85b4ec0de031','5f665521-9f88-4008-8a24-b8678bd39f94','pk_group',null,null,'~',204,'','','','','','','','N',0,'N','N','N','N','N','Y','Y','Y','refer','集团',20,NULL,'pk_group','=@','等于@',2,'c0ab91f6-8bf3-48a9-b9ab-50b3e532e067','','/common-ref/','组织_集团','N','','refpk',1,'','2022-02-20 13:34:57','N','Y',null,1);
            go



